SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE VIEW dbo.vwbSSolicitudesSoporte
AS
SELECT     dbo.vwrSEstados.Descripcion AS Estado
FROM         dbo.vwrSEstados LEFT OUTER JOIN
                      dbo.Tb_SSolicitudesSoporte ON dbo.vwrSEstados.ID = dbo.Tb_SSolicitudesSoporte.IDEstado

GO
GRANT SELECT ON  [dbo].[vwbSSolicitudesSoporte] TO [Informatica]
GRANT SELECT ON  [dbo].[vwbSSolicitudesSoporte] TO [RegistroTitulos]
GRANT SELECT ON  [dbo].[vwbSSolicitudesSoporte] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwbSSolicitudesSoporte] TO [Soporte]
GO
